﻿using System;
using System.Data;
using WP.Commons;

namespace WP.RM.DataEntity
{

    //=========MCity  ============================
    [System.ComponentModel.DesignerCategory("Code")]
    public class RMSetDEL : DataSet, IDataEntity
    {
        //=========mCity ============================
        public const string TABLENAME_RMSet = "rmSet";
        public const string RECID = "RecId";
        public const string SetID = "SetID";
        public const string SetName = "SetName";
        public const string Length = "length";
        public const string Width = "Width";
        public const string Height = "Height";
        public const string GramWeight = "GramWeight";
        public const string RECSTAMP = "RecStamp";
        public const string Remark = "Remark";
        public const string SetSize = "SetSize";
        public const string CategoryID = "CategoryID";
        public const string CategoryName = "CategoryName";
        private System.Collections.Specialized.NameValueCollection mVarCollection = new System.Collections.Specialized.NameValueCollection();
        public System.Collections.Specialized.NameValueCollection VarCollection
        {
            get { return mVarCollection; }
            set { mVarCollection = value; }
        }

        public RMSetDEL()
        {
            //Create mCity structure
            CreatemCityStructure();

        }

        //=========mCity============================
        private void CreatemCityStructure()
        {
            DataTable table;
            DataColumnCollection DCC;
            DataColumn DC = new DataColumn();
            table = new DataTable(TABLENAME_RMSet);
            DCC = table.Columns;

            DC = new DataColumn(RECID, typeof(System.Int32));
            DCC.Add(DC);

            DC = new DataColumn(Length, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(Width, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(Height, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(GramWeight, typeof(System.Double));
            DC.DefaultValue = 0;
            DCC.Add(DC);


            DC = new DataColumn(RECSTAMP, typeof(System.Byte[]));
            DCC.Add(DC);

            DC = new DataColumn(Remark, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(SetID, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(SetName, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CategoryID, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(CategoryName, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(SetSize, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            
            this.Tables.Add(table);
        }
    }
}
